DROP ROUTINE

DROP ROUTINE — Remove a routine

Synopsis

DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype

[, ...] ] ) ] [, ...]

[ CASCADE | RESTRICT ]

Introduction

DROP ROUTINE removes the definition of an existing routine, which can be an aggregate function, a regular function, or a procedure.

For descriptions of the parameters, more examples, and further details, refer to DROP AGGREGATE, DROP FUNCTION, and DROP PROCEDURE.

Examples

# Drop the routine foo for the type integer:

DROP ROUTINE foo(integer);

# This command works regardless of whether foo is an aggregate, a function, or a procedure.

See Also

DROP AGGREGATE, DROP FUNCTION, DROP PROCEDURE, ALTER ROUTINE

Note that the CREATE ROUTINE command does not exist.